www.gusucode.com > DB-Libray 操作SQLServer编程的VC++ 一例-源码程序 > DB-Libray 操作SQLServer编程的VC++ 一例-源码程序\code\PhManage\PhysicM.cpp

    // PhysicM.cpp : Defines the class behaviors for the application.
// Download by http://www.NewXing.com

#include "stdafx.h"
#include "PhysicM.h"


#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CPhysicMApp

BEGIN_MESSAGE_MAP(CPhysicMApp, CWinApp)
	//{{AFX_MSG_MAP(CPhysicMApp)
	ON_COMMAND(ID_APP_ABOUT, OnAppAbout)
		// NOTE - the ClassWizard will add and remove mapping macros here.
		//    DO NOT EDIT what you see in these blocks of generated code!
	//}}AFX_MSG_MAP
	// Standard file based document commands
	ON_COMMAND(ID_FILE_NEW, CWinApp::OnFileNew)
	ON_COMMAND(ID_FILE_OPEN, CWinApp::OnFileOpen)
	// Standard print setup command
	ON_COMMAND(ID_FILE_PRINT_SETUP, CWinApp::OnFilePrintSetup)
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CPhysicMApp construction

CPhysicMApp::CPhysicMApp()
{
	pMainFrm=NULL;
	
	// TODO: add construction code here,
	// Place all significant initialization in InitInstance
}

/////////////////////////////////////////////////////////////////////////////
// The one and only CPhysicMApp object

CPhysicMApp theApp;

/////////////////////////////////////////////////////////////////////////////
// CPhysicMApp initialization

BOOL CPhysicMApp::InitInstance()
{
	

	if(!AfxInitRichEdit()) return FALSE;
	try{
		if(!DBSession.Connect("sa","9605001","127.0.0.1")) return FALSE;
#ifdef _DEBUG 
		DBSession.SetDataBase("Demo");
#else
		DBSession.SetDataBase("physic");
#endif
	}
	catch(DBErr *dberr)
	{
		char *err;
		int errcode;
		dberr->GetLastErr(errcode,&err);
		AfxMessageBox(err);
	}

	AfxEnableControlContainer();

	// Standard initialization
	// If you are not using these features and wish to reduce the size
	//  of your final executable, you should remove from the following
	//  the specific initialization routines you do not need.

#ifdef _AFXDLL
	Enable3dControls();			// Call this when using MFC in a shared DLL
#else
	Enable3dControlsStatic();	// Call this when linking to MFC statically
#endif

	// Change the registry key under which our settings are stored.
	// TODO: You should modify this string to be something appropriate
	// such as the name of your company or organization.
	SetRegistryKey(_T("Local AppWizard-Generated Applications"));

	LoadStdProfileSettings();  // Load standard INI file options (including MRU)

	// create main MDI Frame window
	CMainFrame* pMainFrame = new CMainFrame;
	if (!pMainFrame->LoadFrame(IDR_MAINFRAME))
		return FALSE;
	m_pMainWnd = pMainFrame;
	pMainFrm=pMainFrame;
	// Parse command line for standard shell commands, DDE, file open
	CCommandLineInfo cmdInfo;
	ParseCommandLine(cmdInfo);

	// Dispatch commands specified on the command line
	if (!ProcessShellCommand(cmdInfo))
		return FALSE;

	// The main window has been initialized, so show and update it.
	//pMainFrame->ShowWindow(m_nCmdShow);
#ifdef _DEBUG
	pMainFrame->SetWindowText("药品管理测试版 V1.30");
#else 
	pMainFrame->SetWindowText("药品管理系统 V1.40");
#endif
	pMainFrame->ShowWindow(SW_MAXIMIZE);
	pMainFrame->UpdateWindow();

	return TRUE;
}


/////////////////////////////////////////////////////////////////////////////
// CAboutDlg dialog used for App About

class CAboutDlg : public CDialog
{
public:
	CAboutDlg();

// Dialog Data
	//{{AFX_DATA(CAboutDlg)
	enum { IDD = IDD_ABOUTBOX };
	//}}AFX_DATA

	// ClassWizard generated virtual function overrides
	//{{AFX_VIRTUAL(CAboutDlg)
	protected:
	virtual void DoDataExchange(CDataExchange* pDX);    // DDX/DDV support
	//}}AFX_VIRTUAL

// Implementation
protected:
	//{{AFX_MSG(CAboutDlg)
		// No message handlers
	//}}AFX_MSG
	DECLARE_MESSAGE_MAP()
};

CAboutDlg::CAboutDlg() : CDialog(CAboutDlg::IDD)
{
	//{{AFX_DATA_INIT(CAboutDlg)
	//}}AFX_DATA_INIT
}

void CAboutDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAboutDlg)
	//}}AFX_DATA_MAP
}

BEGIN_MESSAGE_MAP(CAboutDlg, CDialog)
	//{{AFX_MSG_MAP(CAboutDlg)
		// No message handlers
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

// App command to run the dialog
void CPhysicMApp::OnAppAbout()
{
	CAboutDlg aboutDlg;
	aboutDlg.DoModal();
}

/////////////////////////////////////////////////////////////////////////////
// CPhysicMApp message handlers



int CPhysicMApp::ExitInstance() 
{
	// TODO: Add your specialized code here and/or call the base class
	DBSession.DestroyDBSession();
	return CWinApp::ExitInstance();
}
void CPhysicMApp::Delete(CString TableName,CString TableColName,CListCtrl *pl,int col)
{
	if(pl->GetSelectedCount()<=0){
		pMainFrm->AddLog("请选择相应记录后再执行删除操作");
		return;
	}
	CString tmp;
	int i=pl->GetSelectionMark();	
	tmp=pl->GetItemText(i,col);
	if(AfxMessageBox("确实要删除ID="+tmp+"的记录吗?",MB_YESNO | MB_ICONQUESTION | MB_DEFBUTTON2 )==IDNO)
		return;

	DBLibrary DB(DBSession);
	try{
		DB.ExecSQL("delete from %s where %s=%s",TableName,TableColName,tmp);
		pMainFrm->AddLog("删除%s表中%s=%s的记录",TableName,TableColName,tmp);
		pl->DeleteItem(i);
		char index[3];
		for(int i=0;i<pl->GetItemCount();i++)
		{
			sprintf(index,"%03d",i+1);
			pl->SetItemText(i,0,(LPCTSTR)index);
		//	m_ProviderList.Update(i);
		}
		//m_ProviderList.Update(
	}catch(DBErr &err)
	{
		char *str;
		int ecode;
		err.GetLastErr(ecode,&str);
		pMainFrm->AddErr(str,ecode);
	}catch(...)
	{
		pMainFrm->AddErr("unknow error!",-1);
	}	
}